2014-06-11 - 13208 - Spec - Scorecard Japan E-commerce #JapanBI #japan
SPECIFICATIONS
13208 -Scorecard Japan E-commerce
Requirement Summary
Need to create a report to show differences in Sales.
Admin Info
Purpose
|
Scorecard Japan E-commerce
|
Requested By
|
Mark Harris
|
Spec Created By
|
Praveen Guntuka
|
Spec Created Date
|
06/11/2014
|
Spec QA by
|
Uday Kumar P
|
Objects
|
Japan E-Commerce
|
Document Status
|
Complete
|
References
Prior Tickets
None
Documents
None
Functional Requirement
1. Need to create a report using Japan Daily Report.csv data source to show Period, Year, Country, Shipped revenue for specified Year and Period.
2. Need to schedule the report twice, one before 09:45 AM EST and another after 09:45 AM EST.
3. Need to set the output format as MS Excel.
4. Need to create another report based on these two excel files and it should show the differences in sales.
Solution Summary
1. Need to create a report using Japan Daily Report.csv data source.
2. Need to use the Japan Daily Report.csv sheet from [[file://\\10.115.101.38\reportdatasources\SaScorecard\JapanInbound|\\10.115.101.38\reportdatasources\SaScorecard\JapanInbound]].
3. Need to set the restriction on Country.
4. Need to show Period, Year, Country and Shipped Revenue.
5. Need to apply restrictions on Year and Fiscal period.
6. Need to Schedule the report twice in a day.
7. Need to set the file format is MS Excel.
8. Need to export these sheets to Share location.
9. Need to create a report based on exported sheets to find the differences in Sales.
Test Plan
SNo
|
Test Scenario
|
Expected Results
|
1.
|
Execute Crystal Report in Crystal Designer tool after changes.
|
Report should execute successfully in Crystal Designer tool.
|
2.
|
Schedule the Report in NEC BI Launch Pad.
|
Report should execute successfully in NEC BI Launch Pad.
|
3.
|
Validate the report with sheet values.
|
Report should successfully validate with Sheet values.
|
Solution Details
1. Need to create a report using Japan Daily Report.csv data source.
2. Need to use the Japan Daily Report.csv sheet from [[file://\\10.115.101.38\reportdatasources\SaScorecard\JapanInbound|\\10.115.101.38\reportdatasources\SaScorecard\JapanInbound]].
3. Need to set the restriction for Country is 'EC'.
4. Need to display Period, Year, Country and Shipped Revenue.
5. Need to created Parameters for Year and Fiscal period.
6. Need to Schedule the report twice in a day that is before and after 09:45 AM EST.
7. Need to set the file format is MS Excel.
8. Need to name the excel files as "Japn_ECommerce_Previous.xls" and "Japn_ECommerce_Today.xls".
9. Need to export these sheets to Shared location.
10. Need to create a report based on exported sheets to find the differences in Sales.
Issues
None